The purpose of this project is to evaluate how Airbnb listing information compares within NYC. Since Airbnb is gaining marketshare in the tourist accommodation market, which has been dominated by hotels, hostels, and motels in the past, and pricing have changed overtime, our group believes it is important to find the impact Airbnb will have on the future.
Dataset Source: Kaggle
The NYC dataset has over 48895 observations recording over 16 features for each house that hosted Airbnb guests in 2019. Among the features are room type, price, host name, and so on. According to the dataset, 22326 private rooms, 25409 Entire homes/apts, and 1160 shared rooms were hosted in 2019. The most expensive of them being 10000 and the least expensive being 0. Note that some airbnb housese can claim to have zero dollars in price per night because they don’t charge per night, rather by week or month. The most popular neighbourhood is Williamsburg, while the most popular neighbourhood group is Manhattan. Lastly, the sum of all reviews posted to Airbnb in 2019 is 1138005.
This table investigates and compares how the average Airbnb listing information such as price, number of minimum nights required, and room availability out of 365 days, compares between different NYC neighborhoods. In order to make this comparison, the listing was grouped by neighborhoods.
| Neighborhood Area | Average Price for a Room ($ USD) | Average Minimum of Nights Required for a Room | Average Room Availability out of 365 Days (Days) |
|---|---|---|---|
| Bronx | 87.50 | 4.6 | 165.8 |
| Brooklyn | 124.38 | 6.1 | 100.2 |
| Manhattan | 196.88 | 8.6 | 112.0 |
| Queens | 99.52 | 5.2 | 144.5 |
| Staten Island | 114.81 | 4.8 | 199.7 |
Interpretations & Insights:
Purpose: This chart was meant to visually inform the viewer of how the number of Airbnb listings vary per neighborhood. Using a bar chart can help allow the viewer to easily contrast the different number of listings between neighborhoods.
Insights:
Purpose: This chart was intended to show the distribution of Airbnb-hosted houses in New York City to expand the user’s perspective of which neighbourhoods seem to dominate the real estate market (in terms of temperoray renting).
Insights:
It appears that houses closer to a coast or near central NY appear to dominate the map. Perhaps because people are attracted to the view.
The popup labels reveal that house prices in densely populated Airbnb markets, on average, are much higher compared to regions with fewer Airbnb houses for guests.
Purpose: This chart is intended to show the portion of types of different rooms on Airbnb in New York City. A pie chart is very useful in this situation because it gives people a intuative way to understand the proportion of different room types.
Insights: